SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475417 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475417 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55338,75993,115564,59951,66152,555393,212661,9944,125593,83985,359588,532282,121260,168140,655853,841330,437414,142447,221122,859668,989398,726287,282799,312542,969048,922135,639825,952146,519380,1043852,386376,397002,255372,274352,874994,159383,290497,373691,524233,484347,452764,991978,379142,677092,521689,442003,854299,1021141,510214,699281,987140,414327,1010456,763609,1041146,196733,115814,1007859,706224,701377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]