SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037562 LIMIT 1 [ RunTime:0.003704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037562 [ RunTime:0.011477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493288,579775,234742,482732,479892,857518,40940,436259,491396,691142,895412,155427,821749,613218,595341,149973,796165,108141,657121,546063,510307,370378,312976,116385,1008717,754726,546158,115951,778229,820035,357466,628372,1032778,281117,964972,207941,776507,35897,330341,254508,704738,2773,245622,267081,310428,520244,1035824,762680,255867,1030967,147044,531230,137307,515433,629271,775440,44821,820265,115401,224354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001165s ]