SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041117 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041117 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482882,795212,351289,243405,854936,25567,173316,300398,146590,484861,722126,503362,30072,451476,880026,535189,897461,346646,944070,533191,285031,348115,458662,449826,962934,179994,1041366,94548,638993,625935,691146,294119,117013,53280,570209,460558,83715,593986,212064,879852,303010,337466,552927,717213,150814,45534,104013,378341,1006302,699907,186260,909735,538213,573151,468719,798299,425306,249909,622367,396290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]