SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489630 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489630 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981381,50457,511236,123029,734454,310263,121052,481093,508116,1034255,23007,331166,458997,219206,90864,72966,806014,995319,754925,892493,314502,881754,635368,111963,806598,924448,418535,1029161,549369,285208,49881,195869,452600,929398,577212,157661,797888,788703,367872,758662,74083,186911,624951,447695,659279,351320,915965,844165,478634,1017147,723983,245400,298037,441486,69987,600102,781628,378035,680492,368631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000352s ]