SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018601 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018601 [ RunTime:0.003995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488203,207658,885596,1621,432924,442950,907972,131682,586476,175707,345193,273245,221238,574748,683131,726047,206871,416212,874720,173067,6680,34450,958101,971285,698819,102345,171348,857230,567468,988769,730567,878313,819566,505226,186290,230253,73001,932280,514952,188188,786408,9815,16546,989264,34855,869065,895835,933332,350854,6857,834756,971124,130848,14907,377760,295188,426646,505121,647901,1012358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001835s ]