SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504874 LIMIT 1 [ RunTime:0.004904s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504874 [ RunTime:0.004557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628879,111807,69462,131666,507308,676499,1037463,947775,698315,639454,1026924,8060,232186,342052,843665,475482,82516,976179,137142,486393,948627,418080,20583,356828,534077,1036745,45235,233095,67555,275981,762901,953467,838733,681024,395650,172101,41569,879181,141740,500219,867921,783278,27400,731948,159554,620711,383288,582374,880351,908713,114446,907027,682803,168073,36405,937113,809291,848150,59629,386083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504874 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504874 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]