SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043557 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043557 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391418,304927,175776,552509,240477,1000390,327248,328154,359079,452320,472689,640581,619536,672457,812407,489168,486669,692119,1023926,480362,261048,604551,1008464,621511,288579,448897,1047938,19009,56355,654161,62172,559367,811634,718609,424447,163366,368171,239367,688305,859088,259090,340962,188794,541025,456459,59274,546312,930412,622908,88651,365238,406121,189664,975513,129669,355302,49183,616028,207108,612634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]