SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543930 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543930 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196921,430275,411807,225149,135499,267700,486044,277672,271947,436000,742318,6069,919211,407135,814193,824567,799496,318364,51652,1036968,95885,174228,1022733,502787,495302,169189,905939,869742,938375,496283,325203,366968,1035640,154449,261956,1016930,739120,330949,812443,705055,89701,269925,216635,181680,372581,683709,1042143,58509,793183,744715,206357,67073,883334,727253,370009,216146,489582,629712,438832,224022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]