SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510728 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510728 [ RunTime:0.002563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140557,649350,224974,510674,343044,971348,553986,1019389,1023387,909951,810962,313618,831511,301406,744240,581774,612462,631323,619896,731773,141167,955324,671637,600460,375846,162614,513958,805127,1012627,441606,205751,903507,914916,682881,568545,262778,652937,931796,595511,362568,984567,545817,800121,925295,188394,301004,90774,697695,620663,23376,221022,328207,489387,977305,888066,563416,757649,521970,967361,543470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]