SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469704 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469704 [ RunTime:0.003741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286892,314316,56929,629668,522071,235344,332550,678808,151630,571886,98017,361450,743092,430574,562764,109482,172347,972066,517199,840970,843691,834672,719965,430537,233799,630406,160186,1026732,902908,677040,316160,499486,601311,971682,823220,224554,47403,639820,261382,435802,619748,343592,583206,205294,136313,720112,636545,377022,280260,792547,213641,390352,896797,470413,941527,754822,780322,611604,620516,141975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]