SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012316 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012316 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152584,1048778,674967,933659,931493,566747,626881,223677,9874,42252,890913,356174,643779,569594,11365,693804,747666,586530,703916,75278,503236,768314,573541,126026,290515,55703,309454,347912,685461,509453,811981,918332,753095,1019743,933667,962023,964135,475139,660546,454241,540741,416549,281578,501727,15521,981292,664770,561345,537496,40734,975786,839960,206224,618332,363246,365056,68100,883729,864080,474137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]