SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035247 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035247 [ RunTime:0.003043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122140,1015791,1022799,41113,75022,297217,215323,160634,351025,1006591,512170,776566,138166,348436,178639,536053,935955,222492,153094,734164,704462,71267,683415,117750,233824,955513,151767,1030075,786615,914187,676308,575901,621520,39398,540100,412545,871482,343316,39477,428644,1047763,670158,660358,698801,465692,74391,457431,741320,745403,211036,688549,996424,225722,803941,359719,788912,159448,737590,538652,444614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]