SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267646 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267646 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563593,59131,294845,915544,837873,859761,117061,733213,334280,705866,726960,121093,237506,253482,201348,298779,990188,909147,92366,931037,24383,443398,325964,1017014,180880,335016,313387,480825,600296,51432,877524,9420,1037750,889349,584982,462371,591053,670609,839883,1004883,521725,315256,84170,983444,90866,1023433,137084,283621,951924,426461,405048,789210,742344,990065,931612,539660,1033496,886531,853430,1020964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]