SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507274 LIMIT 1 [ RunTime:0.002977s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507274 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749859,99437,1030227,158413,320217,579534,328083,978226,117291,147493,113522,909746,670782,141010,616792,1039957,464452,403983,458995,221599,435189,931338,508052,306210,489730,869228,433650,276792,729121,809197,355984,271620,558796,182731,442121,351533,179220,652923,1010660,15003,775940,334273,387591,626927,913517,571765,669217,420760,332257,478336,483512,473981,900810,597943,568193,347800,87155,596786,887082,228601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]