SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494406 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494406 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70450,825685,222174,76104,822341,27239,729074,502778,853289,973109,101830,389162,775003,1032077,498250,7293,312245,674530,281076,306536,733817,411847,108576,55163,712781,895251,132072,662938,326409,269528,796611,924603,181784,150414,77996,595299,308288,671674,1029719,327522,561418,184943,1011818,903973,902700,293288,465844,13326,1009010,664616,1028881,367543,359095,600969,231055,463628,473991,928904,612247,165420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]