SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023356 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023356 [ RunTime:0.003430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526108,501701,412973,567688,663906,257445,385463,643520,305416,693003,235488,705727,798643,615453,404452,953336,154647,385120,399924,318088,358796,182996,467495,855622,203471,1025611,159384,634988,170069,534735,901559,348476,354304,802526,489914,113011,529108,134409,286681,998415,621251,973154,910315,719326,1023222,533446,914115,835844,859187,138711,853421,668531,507320,896159,617957,134100,528210,144525,898564,193571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023356 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023356 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]