SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341213 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341213 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3842,756659,1023904,719163,603792,284507,460151,118672,1006703,409287,315808,155664,1048860,545670,73054,1020747,647208,236686,849256,577556,672711,754892,270457,206719,600363,442797,195836,112338,843061,194821,367593,1040066,378878,613429,428561,621536,901464,55207,654379,21676,239020,726971,434786,522166,170901,709877,676578,379958,772274,921171,364848,542799,387608,327320,509875,400522,875302,130519,277369,838448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001180s ]