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` = 521034 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521034 [ RunTime:0.004715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80050,1027218,423233,550573,133864,553748,84811,430209,744608,321594,806323,227131,160966,344674,100731,77925,580191,880429,841478,780686,455132,665855,313839,227584,116349,283265,89394,329889,677743,649177,872376,247605,127940,1000369,213608,324615,1040456,747381,228384,977890,426564,647296,407076,362474,289608,120416,197780,662630,1031746,427914,1029107,260738,315240,531828,358480,923852,384075,1046102,1013960,657654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]