SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409056 LIMIT 1 [ RunTime:0.003216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409056 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938869,1036380,913415,554109,196875,600368,326360,140524,310202,327943,700807,928982,10050,741138,646885,440844,657859,670377,266418,814146,877537,571877,733012,209251,765440,622991,341196,648945,411471,442145,384088,129958,342876,639292,711214,236330,341116,841482,569060,978577,757055,720951,357200,899033,373470,402946,520316,795829,176365,378911,236998,337884,295764,788302,702424,903847,198244,178201,161421,173373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]