SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455956 LIMIT 1 [ RunTime:0.000809s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455956 [ RunTime:0.002471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614344,404212,165417,426066,767609,741512,687144,883312,1014320,896314,392310,434806,192017,34110,296271,517395,545191,4961,987621,19199,306726,113439,130325,705775,463013,65567,384462,469146,95961,739497,788015,176476,315554,216883,470691,973380,31074,102411,557259,965888,623350,761526,981222,77207,775174,572206,118250,290194,841650,146751,776519,100782,140508,194452,154880,99413,602228,110737,234832,429112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003639s ]