SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343798 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343798 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224311,888302,849803,666153,634643,737770,730040,420569,151755,70486,128974,404042,1026699,353767,590557,362304,458259,568027,296250,625903,990013,249217,227320,154620,54611,1028700,640250,483670,1036109,750969,266625,902897,809143,238144,413116,275269,804152,353955,647193,85320,239398,712553,922404,661983,755412,58065,675207,124544,290544,877498,527727,415810,285247,512765,345335,999034,1013702,904248,453097,371965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]