SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417482 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417482 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649600,662198,989043,721417,987969,813218,541281,55683,769471,400570,1014270,536958,302809,813958,633685,99116,774311,154435,139356,571109,292464,51263,615907,800891,217050,215881,74053,138847,738473,627241,124519,113689,81324,213061,159559,714018,283525,507784,952705,849610,961280,915367,686608,200380,108203,101045,846166,441004,518599,492067,917637,757981,152821,799609,1006755,732188,776833,626345,126396,105849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001842s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000904s ]