SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404236 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404236 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375628,286392,833569,163678,538239,292399,5274,163903,1031993,404658,344513,782070,671311,751736,296196,64689,549735,345098,229178,117079,587211,346243,597033,858243,953375,916073,924678,638768,789083,589798,991110,575463,113792,813864,563691,970751,738378,131966,2769,849709,993979,466713,580510,541634,35051,577734,325736,307077,451910,139663,964939,938676,1014773,63154,731357,478669,845970,591571,264523,468490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]