SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019072 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019072 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554158,679773,483118,795751,976071,718959,788815,38365,708808,256794,931713,258910,679181,95532,359228,1018460,768799,997679,1341,884673,692227,20017,927279,603154,611343,267333,685972,1008151,126865,180290,468284,538035,192624,854722,66036,38298,863334,572686,25964,588527,161029,147163,1009024,82195,675010,667314,519977,314815,62268,341912,762185,4005,958628,635310,747804,964039,356679,588866,999782,492012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]