SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505799 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505799 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520136,371963,52839,315686,631218,974708,53968,678741,1014216,187821,762047,333595,554321,887092,329028,5022,162257,582497,70750,111113,630535,12751,1043274,947389,265880,19123,17293,897958,734002,998470,821726,701508,486537,51754,340282,80049,119529,1179,82439,398368,1031709,1017784,986270,276471,776923,175343,87359,629975,245768,545254,572840,651396,940187,752279,828775,544018,151351,167200,408655,388197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]