SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918413 LIMIT 1 [ RunTime:0.000827s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918413 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580894,157087,300027,152766,9714,864014,971571,395150,291121,490880,661658,825932,533983,603188,798973,172691,596789,1035640,657855,257127,203460,646755,397240,266427,728034,586905,1004724,531892,979169,297660,419861,23482,859383,310128,966270,726073,713909,784636,78812,905507,647978,1009053,118526,843628,215458,61160,507116,595660,267044,464122,729631,813389,835052,389264,756608,520201,604492,623163,502805,226431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]