SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028801 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028801 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214076,1044660,980504,884579,689847,521864,897135,79831,580816,1043234,808834,879787,395722,321379,462026,693633,567609,890754,498951,762373,90679,756490,1002708,508101,935025,776449,845485,657271,316448,622127,877049,383820,788585,824347,761540,480728,519693,863422,257716,920264,849278,514946,791890,988385,432277,33152,1035306,856453,217721,532516,322907,608773,700637,218372,579788,153820,977664,616481,406947,262644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]