SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496014 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496014 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820367,744017,803347,768090,674752,173524,154372,209805,462107,447022,629637,187427,220148,984109,95891,127704,704295,380086,369016,101253,818474,768187,788516,357343,48849,764561,853750,221363,730701,122062,67082,12011,164374,30050,350585,556660,600109,351081,631799,304079,473745,853663,393389,1009724,700797,933783,724653,990593,751615,1025551,287202,351293,928497,1008378,134003,699487,126414,590808,853531,394108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]