SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584890 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584890 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405915,38931,994230,992020,166929,982763,160928,267522,763861,334751,918922,938768,432097,86212,847832,441234,1034702,1035101,630604,623952,968164,134302,491824,267043,335964,1000741,390835,355902,74951,71142,264634,872958,732299,784284,737599,424229,761146,241446,992310,901967,509529,288869,320388,850478,381234,107988,565490,684316,895848,264150,870813,982774,953957,570483,40121,1002656,516183,939386,714122,497980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]