SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201116 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201116 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122212,478289,337755,130963,911226,952771,920974,743814,999594,56259,533745,921100,411928,231240,755266,255395,775882,295413,875926,448916,764908,104946,777351,713801,126853,817808,519010,479176,549958,875544,176639,455953,297328,34900,594638,943236,390879,470099,695775,1015934,553967,876064,360936,1038383,470125,991263,965558,719281,4770,369828,610754,165815,552635,113164,815204,674060,425852,846934,89857,945601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]