SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106079 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106079 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513961,947658,604806,235861,229853,1046014,469864,297385,877056,400606,830837,950974,481820,717610,1035347,808628,1565,842014,965036,696452,244004,71125,755119,416147,360937,990036,31013,443020,1006456,522261,636078,910161,316807,323193,1038659,21270,57012,150037,886372,747733,618182,647773,957756,623267,758549,408682,338361,837538,951373,339300,811194,719739,284396,460554,7681,1027015,223877,117688,175448,789827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]