SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520517 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520517 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20891,394648,1042575,61204,234255,546351,463818,376945,399665,905240,131556,410102,131822,548467,563434,770178,818117,276680,127991,490220,329140,150286,573027,905119,804206,819699,317706,224441,929753,804220,179116,202997,431344,240502,914898,769415,961008,850321,914232,204398,628540,337829,150004,762890,327833,388696,310544,523237,366066,655779,1048593,327530,936229,811628,14972,832738,64154,777978,794185,612738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]