SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039237 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039237 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824803,850107,612551,173103,292000,866027,119190,143434,117298,363739,772090,385922,943561,16093,757221,1042133,484156,63518,358299,382819,368822,409140,534831,469506,419351,679355,141408,1027487,508437,801279,919509,1036110,401133,191241,740226,89110,1024308,462822,964386,881905,484814,320124,226118,39638,883509,375795,40290,534063,997199,836355,527324,334891,862531,704101,1028930,181478,515323,28568,114289,697244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039237 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039237 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002167s ]