SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390683 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390683 [ RunTime:0.002691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340232,985558,549709,545543,8170,902176,468830,414408,714791,907141,36821,122194,606282,759901,505846,391622,897122,323961,495230,693732,334370,799630,857814,708297,309684,566952,437074,4516,130090,823387,758399,500899,338243,675575,1019129,851639,186101,529497,444964,656707,402017,873417,594138,1047538,1040066,70703,768097,993385,393440,737973,65868,174650,571497,13095,78025,923717,982897,228880,26020,677023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]