SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435412 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435412 [ RunTime:0.003153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13969,1017319,1022578,139259,545634,1007450,80735,242430,178869,925685,676231,949929,273306,560448,976324,1047152,481259,855405,284210,368112,312969,595181,841508,880393,626979,975555,13956,978005,956259,205390,342706,568741,514676,391523,468144,245160,168325,792147,366191,822534,88377,784330,691259,798328,44848,746131,807606,79748,338629,733914,476861,845761,295088,87575,334726,751535,572696,301410,90792,210803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]