SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281242 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281242 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013602,875920,437591,961711,565435,262152,990252,473006,397174,628638,110963,166258,1038659,925115,709788,562286,668706,9578,163201,1031074,192810,748892,839459,319989,2007,171189,227464,388252,743264,439563,466205,606186,865097,503366,336900,842939,596391,514326,88600,75209,93296,477892,651563,611430,346795,238147,241673,569432,996481,805070,288225,63009,923910,319322,718055,1010956,244232,508602,603743,786018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]