SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564939 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564939 [ RunTime:0.002714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200357,125817,178717,728595,1012495,652512,300095,343467,98626,1030701,984115,962547,525501,366855,307158,404156,262556,79938,403639,546687,850500,348609,29416,455721,1047163,700052,133385,614482,88249,498134,466947,360772,364218,812199,612784,657904,726738,594560,279668,66754,996078,314698,768437,398018,794292,592429,266728,239132,46976,538504,22354,890288,38593,161763,322983,760414,1013310,927806,311526,1027999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]