SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51900 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51900 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95496,701829,635559,871920,649303,892980,875343,907599,941094,187608,118803,796281,1024337,921929,888849,524579,592049,70572,770517,747110,231651,896149,299480,811981,1042993,586588,510499,928583,404921,838716,801865,52970,1010857,1045118,500628,273597,500064,487398,24371,499930,198599,742861,762662,119924,1044808,515333,829177,403911,878889,98850,388572,882465,406039,405492,8769,464089,508457,548007,844724,495749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]