SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576793 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576793 [ RunTime:0.002833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305049,691716,963614,1030565,715704,396157,35216,302456,996895,934633,377019,686864,1015361,872754,202542,837865,311826,737280,866036,985096,737283,370868,565456,827711,133781,394264,543225,456475,794985,425541,407669,149193,944551,223770,281984,224812,514061,45808,346254,459218,701811,654229,673833,771020,528777,922165,550538,1013922,849240,1007941,700206,165332,277115,917437,535987,735273,868892,292473,104205,782693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]