SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047091 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047091 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568762,621262,785709,391368,957356,622665,87635,719092,195604,415076,817625,736376,543161,281665,295398,874024,85251,897610,1010998,1045056,379137,565297,796348,660504,342555,880688,968828,473750,533649,558202,1030626,446818,181213,388752,698336,22847,343056,606338,242590,225405,185139,550482,828829,408088,446225,465720,797102,450583,257404,1040854,548002,106605,342137,419099,1046915,410262,908888,80403,320921,521874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]