SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345816 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345816 [ RunTime:0.003391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246472,344754,998229,234973,160190,229827,781452,275004,250100,395918,667782,466417,300825,274453,358015,569856,438232,105028,310658,382611,455474,622643,161362,352579,515788,562555,957657,18055,789011,1023117,209142,65196,177728,659257,514815,770141,952303,494985,713421,35451,228705,579649,649054,741259,174497,382845,41467,699676,534014,116419,528258,92269,626871,452916,149230,192432,61575,229561,191744,476709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]