SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521199 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521199 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101907,1027558,740012,1029944,265402,897450,335203,51019,613477,286232,184098,53270,1009051,93675,388280,864464,236194,317697,46287,1041152,939128,859293,513984,647481,317108,920475,932540,744996,28506,206162,508032,728845,376063,543815,941348,568461,247388,678472,509770,959783,259937,403904,779645,348283,256240,32820,177031,129419,134249,210153,420899,281391,601669,765813,521839,438732,508270,866987,3596,872986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]