SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11410 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11410 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625830,318157,199042,516111,498657,1027865,132867,436193,253315,200144,1307,78664,118270,498136,331095,395181,77845,1031562,696217,390391,220217,156678,547018,294363,674832,939053,580447,592083,230195,55884,257810,658319,616017,1027885,287105,226973,885309,744340,595486,410040,943691,1006380,260537,735929,403235,805270,886790,1012494,992659,14483,233601,249125,533324,124709,821281,897434,682840,182621,375636,54728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]