SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531226 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531226 [ RunTime:0.003210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606391,403176,258676,794520,387600,1651,163930,10087,198092,78237,628066,130500,810341,891203,423168,460387,475791,976057,164113,889672,123417,496221,684304,691990,948189,98209,537151,115063,981779,496009,445534,834243,852978,53693,736731,975101,82348,32603,410122,61939,612922,979245,1043379,250636,379074,881914,777698,1016878,67779,48477,27024,36119,1011906,526081,993698,121823,588112,444716,980601,290799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]