SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521254 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521254 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278037,1011497,503088,656200,987885,841569,847216,285813,481001,376912,1004139,87142,101328,541352,132728,444285,261044,645866,309740,342756,992133,990550,93860,844433,1030207,183159,137710,938224,360761,1037722,518456,983875,553560,470458,705054,980513,1013846,123579,198220,261758,684436,616870,818147,866086,224618,448590,160980,278455,11161,213763,368317,558314,23368,808398,217599,871946,624240,26419,237088,232144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]