SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431914 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431914 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044048,396802,598987,108722,269588,852388,37498,191236,891161,876813,775162,990054,208231,636808,1000744,128873,946815,566432,1020177,349520,401415,873691,842602,369060,212999,865056,34364,426801,565439,597053,746447,594404,875626,453639,426603,143496,11393,190038,884505,790805,67529,362914,900912,334233,219940,887857,219448,1015543,704055,814774,982623,681183,191586,263509,279773,260475,339644,423743,230630,586778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001128s ]