SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501380 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501380 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246160,71645,377848,350164,1020979,1008987,394253,3826,532217,672322,607899,769092,367227,1020263,251586,177479,656380,871976,656158,869758,407957,437284,462905,233761,534215,377067,341840,349511,307215,144116,802802,115067,633445,590612,596049,387573,251590,576842,148788,772892,904887,338604,232161,16073,756551,241728,229058,612395,242214,1020923,693672,703402,882469,529894,630674,794421,593523,458218,300790,407030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]