SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469733 LIMIT 1 [ RunTime:0.000745s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469733 [ RunTime:0.003345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690159,456082,384395,64141,973472,543066,90639,806307,28850,834257,722697,146230,287330,850211,672136,1029027,563404,716518,271645,455248,9540,320860,287927,773332,873652,467032,793440,138338,1027760,748111,117473,193282,999158,917945,257284,588857,60736,969819,328530,1008043,268331,372719,756923,491517,1001888,493334,912516,791543,607883,627192,132175,160167,336075,105232,146350,599763,808396,712016,298081,769210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]