SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535640 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535640 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223521,614482,1029027,54315,306288,671649,602177,943538,371618,506761,421116,933853,48397,771650,57838,1017607,824052,473943,489788,106152,400322,174029,359765,30501,244604,702581,314549,125179,984586,120780,614869,882120,546048,811780,230862,21038,52419,876650,813118,843297,248422,274569,431185,257184,99451,966664,597197,27073,156818,485611,460168,696341,113944,583660,399362,172046,46836,660065,791924,280470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]