SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281330 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281330 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277129,319056,34180,154599,702459,130859,577175,733999,107908,720143,84418,103212,950075,158549,875789,18504,63839,819178,996364,224082,699209,630743,844778,785424,56392,994987,157104,790059,992059,743147,608232,432185,610744,488293,818822,316580,440072,363973,105954,489178,397098,462811,802437,677928,495018,959512,629576,794160,264694,982907,378352,401240,933357,697877,347972,513245,539426,150125,120485,160397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281330 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281330 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]