SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505631 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505631 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204108,663519,691030,29008,47720,683909,29808,569995,11273,666872,324391,230160,156063,557114,272386,423937,698958,224216,816782,745140,597836,551055,614062,519330,598453,579750,402506,69498,742733,252268,316237,200471,524113,753901,482688,145736,770841,918263,821850,225029,622191,771278,942031,875659,17096,772946,198416,260637,914731,723270,611673,492621,885637,475785,958163,191864,496034,59873,404137,644447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]