SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 813699 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 813699 [ RunTime:0.004066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729378,102174,366735,802197,109679,531104,117501,307880,361644,501122,225043,1008224,124694,50911,579976,427852,536789,282321,952531,408750,970769,162420,926484,688115,225116,805988,281238,927286,473033,775088,20523,126270,754380,646182,70755,557962,979431,932440,326487,456091,282915,941073,667636,629414,959262,118093,865720,420310,895144,533775,783223,645168,104650,632822,6199,43164,320390,487968,63512,382119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 813699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 813699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]