SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144851 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144851 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252709,1001803,413153,802690,289570,60530,595005,322921,271801,77916,843398,885706,557382,101245,948976,1028741,715122,610876,853020,843244,808064,1037001,681130,564104,877780,352438,777290,1012511,21963,497206,381620,397740,973831,479665,1019616,331366,138167,131234,600408,879114,314006,478025,37994,691283,615447,736703,680548,566201,953685,787367,856708,203731,867167,717792,509935,761112,711457,178044,220883,63557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]