SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806822 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806822 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103015,38879,243983,488350,415303,684084,569029,1003100,235527,59547,289599,788538,988718,620114,627469,1037791,718618,159995,547986,671542,102959,582489,781862,730115,785292,884781,251843,812394,7217,930417,890305,1016769,355245,426120,127132,108825,264951,910899,715866,700746,213338,19007,115613,350699,526259,897264,591369,619633,457644,907849,873863,503745,885338,838995,51398,845898,669792,334159,584685,714538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]