SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466043 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466043 [ RunTime:0.003749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376794,439649,843837,220034,487372,46331,711669,577793,573498,601816,217089,802898,295148,284190,160871,682019,49602,547114,731518,879334,774339,964906,890394,429969,204921,501780,956030,1022863,306018,645249,67887,432463,373750,64955,128592,297238,775342,296173,700323,183970,606072,39458,312619,858789,375214,1014276,387477,920702,181199,1038802,502869,812474,421955,826119,561448,994274,734677,702583,181521,1030254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]