SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287601 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287601 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392490,527502,76779,67533,56521,424088,533120,272123,196836,867577,400793,64890,578373,579228,67075,585739,187529,47835,217300,1036790,692165,956795,491433,277920,999095,452989,132565,876856,143296,76501,20067,116977,237614,555376,658031,747478,78045,703281,364241,277678,575762,322485,612109,160183,1023586,602290,486705,788842,918738,916203,353784,479187,881003,54535,994117,641328,458361,906214,38649,1030438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]