SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047499 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047499 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694453,326241,115155,785718,434483,646715,893301,552032,549784,312143,11389,1035444,576052,699567,496960,965476,1031991,947356,27114,1032796,536872,296849,661584,381186,662352,791487,681204,794193,457388,272076,314556,708332,103255,986253,729080,552092,504694,941078,880801,1006870,109640,98203,550024,764218,168228,472427,941136,629264,968366,618020,658545,610395,614060,11876,565648,452836,641093,51025,195740,722428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]