SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527717 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527717 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738671,1036077,209343,1019313,288463,450705,388273,230756,1002615,106392,852678,657281,374605,690810,624474,295322,930367,672457,900808,97367,101595,446184,802008,623396,1027043,882962,411098,1007026,984505,182851,749295,292928,630237,791966,712813,780605,921483,459642,13815,184120,954083,730898,252397,707876,629915,828858,25807,827768,122512,160627,964765,1042289,1015663,568576,630188,247323,480854,1040838,67768,941142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]