SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511 [ RunTime:0.003074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968907,884962,954371,393943,676691,984015,841614,686956,744730,806449,84533,140223,645612,366970,1023835,255386,388828,444303,668572,474855,59288,189653,520408,312045,995286,807904,450341,369270,107778,27735,942166,299181,28902,83575,135471,958130,452846,148636,832216,711706,439019,140210,1030265,97401,278075,623200,254329,24651,528217,236792,1021338,643695,332218,1048599,1044202,23232,267332,982981,532548,704735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]