SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437928 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437928 [ RunTime:0.002503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954164,2323,601357,193132,25029,896631,660319,303265,443229,496743,658486,1045976,1033338,337037,50848,255509,367469,255058,881537,580533,472132,1033701,1010070,916483,935372,30052,516725,497034,967261,664105,351516,1007281,527399,488219,495270,207230,490354,343026,151817,367960,1008139,954309,464021,503722,117842,76345,1025957,355950,794469,4600,280593,358185,580389,657755,924036,311469,305713,8359,640539,235764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]