SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505320 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505320 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861750,494818,538043,1044937,763214,329356,243386,745892,704121,713271,347063,1048310,486874,43888,175393,590351,949536,679117,874675,1248,897622,473244,320830,380429,473881,996954,758041,596176,327577,96126,189232,863379,449455,239074,943444,220867,382933,941355,406666,249940,664935,767550,692722,421446,284770,864782,1002076,558537,253051,2612,254856,178962,881126,123692,316424,833341,134752,900677,849061,893081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]