SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263645 LIMIT 1 [ RunTime:0.011241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263645 [ RunTime:0.009374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31122,910320,127681,19701,770024,195259,716016,1044677,123923,412073,1027589,36421,485537,913327,355004,96437,540080,1013017,320007,1019524,840840,852,42207,11093,283823,818129,127005,490215,631769,754617,105526,13930,3562,841245,875495,424542,121741,742646,312368,806775,149701,90563,981682,825736,50883,206574,64814,890570,312023,754327,188409,948018,1041516,310108,213013,683661,154965,361392,660724,475491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263645 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263645 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]