SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266483 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266483 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518301,341395,508691,327161,48026,464493,239278,80478,604210,805114,535263,337655,963190,366579,665221,1026038,605932,771608,312570,1031606,1006980,479751,529288,491231,102357,990483,650853,549371,11082,622664,451864,558944,845129,624665,91456,833507,114688,1037304,405863,873822,841102,197116,105598,153161,91930,1006514,744130,454753,50537,832418,48516,836176,873454,573250,740946,545220,114851,606840,29458,142777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]