SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281471 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281471 [ RunTime:0.005088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592749,402287,649960,814281,159212,295041,27283,372013,683284,1032481,14834,139006,105935,415928,920680,14480,941549,692311,840842,2682,764355,510812,734888,281634,161620,262480,564751,182705,37857,316625,637004,307457,72066,622518,247564,671529,285703,969748,326982,568727,262992,238340,771823,60073,868571,23095,195530,969850,55077,813174,418995,565709,905567,984267,206469,368063,58392,1022050,796702,661836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004098s ]