SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401843 LIMIT 1 [ RunTime:0.002495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401843 [ RunTime:0.002625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88073,297563,1016267,640709,841645,739907,1032822,701052,965299,965111,476789,207221,572863,464929,317694,487595,594312,416125,551760,873346,160798,724827,620039,11429,661801,602889,162389,449281,98953,608573,92813,286654,111899,181810,9961,35544,836233,271922,204595,411164,300383,110044,560336,108844,428708,799496,892336,122664,949362,398378,593618,210689,801159,39973,316907,1048782,976386,633773,1001354,923311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]