SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414808 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414808 [ RunTime:0.001906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431501,699295,632769,959043,679773,118282,980795,236090,568967,239536,387390,152130,667782,3827,54473,609192,957827,445321,963080,265797,575081,996987,196115,804095,981446,578099,935533,64292,967125,464391,936970,770534,1015239,364152,407964,443085,113018,742760,266462,891447,962594,82389,198036,500144,175609,408630,932440,630131,622463,211110,219835,1015353,583010,479082,1946,837168,127405,604678,258063,924010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]