SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556417 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556417 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598872,777781,122620,404609,473688,81560,120495,351553,563422,231217,161649,7062,34905,133041,198692,655515,262667,852221,641768,989741,162571,348551,840534,264879,218301,129903,102157,944986,8365,975518,20202,904288,30620,700116,885508,667937,80631,998771,825134,216938,138440,610580,304134,557544,699022,564590,513542,798428,417479,886294,646935,150380,23691,529897,383146,589095,70257,204761,485763,758806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]