SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103947 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103947 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558276,794122,24140,66883,674523,793112,442211,602848,348851,1004454,911307,569258,292247,975305,1036760,862102,209879,982347,146990,133007,296609,234030,788364,323591,538428,73632,793786,15307,560204,19286,523728,689118,108057,508523,640390,837728,850182,68404,972168,823272,619612,222381,435480,144674,476305,877053,877496,232920,421031,699157,154509,880478,206304,836243,838948,240837,437179,543110,667034,194152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]