SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311313 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311313 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010082,507805,418969,986819,149456,788055,331817,662097,138531,571588,13873,65534,707685,641482,875643,358965,644117,135079,680733,529566,210308,909231,941953,249594,162882,846791,50600,574570,798759,21034,434723,523620,43853,750747,1008197,967723,445708,72191,902445,193605,957258,998980,700782,838147,646332,70718,795065,504809,522060,328109,883323,182127,832144,818079,431019,596797,776365,904402,96746,802973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]