SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437851 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437851 [ RunTime:0.007561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63815,864956,942730,397141,259984,221563,474608,832868,523874,820815,633288,468420,360286,179545,462950,741115,872718,579342,331390,839378,380196,109003,254818,799696,848499,349423,391504,967891,1022735,511857,233209,151705,311860,64358,701723,241613,284260,733564,491109,470833,865013,662650,253460,563918,310097,383419,240590,91128,540770,400029,216006,607120,642346,570141,862550,208471,454392,709104,531452,880173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]