SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406741 LIMIT 1 [ RunTime:0.001220s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406741 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527659,851009,478709,974974,1034457,220553,998589,57206,534010,100870,457642,365736,427834,814315,318035,594622,784379,990433,957517,15396,137050,838826,451881,655824,394510,985804,543819,572383,442227,471317,816834,612355,726762,1000393,548898,93845,130086,293300,578602,868203,379413,1036233,932100,663954,229952,121164,235522,49491,90549,319295,305988,228421,485900,159998,159912,995658,839539,580149,372090,373600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]