SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318430 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318430 [ RunTime:0.002671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436440,191113,501384,361010,316308,223862,630691,1038529,265805,724088,801620,241944,759158,651232,807875,50121,706962,128327,758923,929315,233629,323167,373191,792383,148529,658256,971328,707880,970908,610208,441702,46974,418137,303574,867214,799829,879473,227698,697594,514107,156064,584931,952743,68538,35399,199617,383650,201146,953441,74655,648762,545546,793440,660725,499899,153474,922197,602067,499197,294296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]