SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118699 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118699 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127124,599513,379267,385871,9122,460094,931592,1046371,69848,728033,193434,452666,250005,1034755,1034606,267611,745109,619226,445514,623758,245497,752581,134572,639875,76895,890999,585065,954336,549793,866863,420552,889538,77100,588766,621545,247202,904391,541455,136673,720932,842634,166248,1048341,598656,782279,804805,128638,1026635,585300,904036,914562,633440,79171,103281,652013,385518,756167,334398,364575,125413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]