SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039814 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039814 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528822,74876,531222,670971,558848,29718,602235,180434,1022818,917416,902253,369019,873022,409326,621012,171653,443080,50452,1026738,1047879,1001996,396243,461059,664058,519787,60982,75256,432886,85244,91097,975088,487896,305741,146399,312801,807935,625167,5580,129882,722933,482919,323127,1020318,987156,625213,623610,426055,286912,687066,469248,602237,512188,268243,570677,778989,736648,51661,806732,589745,395216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]