SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364460 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364460 [ RunTime:0.004179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528447,841893,751696,831400,610937,282201,758267,1009863,197907,886505,458701,427783,544414,652448,329677,829802,382721,29891,806873,755193,198897,929979,480870,845402,966239,620198,499261,183080,701136,458204,135028,13924,547065,307072,576685,87969,701826,363559,36995,79755,624055,273726,202485,769503,421223,982707,416763,832566,634679,732100,525893,110367,739254,501654,877085,592260,582095,443554,311423,191817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]