SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101840 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101840 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017629,68392,243314,445580,295087,390527,89843,518704,336930,652499,745094,328007,639748,126303,140605,271246,98517,755763,795509,775235,207408,84287,43741,916779,748211,783422,30454,242127,744574,843208,809431,699678,744908,335398,83751,694118,165085,58557,340172,806331,373998,37689,137667,138851,1000097,836218,920038,1038317,460628,784958,807670,587559,365005,59940,219126,310450,238744,1021581,866068,1034396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001077s ]