SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4417 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4417 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20869,49920,174250,361547,252486,694000,825077,26787,822236,470239,919511,660487,731580,688098,992199,205199,583803,22423,418067,516439,345471,26571,733619,283442,736958,1035326,794311,1022855,1009893,492080,121487,20432,161963,251712,521231,335661,1045447,367386,956016,455755,794132,603039,346954,85961,919765,931358,784035,1014752,946566,797489,957205,206536,154838,227110,386720,724198,1005356,370934,965082,484067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]