SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554311 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554311 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517212,837332,673439,611103,287497,211262,656846,173526,20456,274442,574199,203173,385461,10565,874522,219133,616588,379850,159873,630457,1038478,1011225,547432,788958,733329,680379,107598,859351,840872,82267,156345,360021,137735,916533,816521,739323,176354,330527,113050,985011,589334,1008287,181233,732549,550289,327237,850533,448373,528960,314481,999481,77550,42626,219991,643624,540751,156349,640092,975995,761608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]