SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416247 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416247 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512191,142228,665805,591865,948569,964020,745659,114827,446886,955690,981087,281885,460853,64706,860241,403984,1038445,293181,161609,285137,1034060,243746,438401,305090,1020918,431656,393698,538001,665231,941072,558346,919737,13012,730088,795811,933378,458997,528138,959381,271797,855802,165966,843794,962917,84731,170914,704553,357699,144134,824036,214352,597431,571540,804286,365191,861601,31736,89716,819678,940273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]