SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509536 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509536 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813673,313858,511486,106716,538173,300609,611232,929221,955091,476901,989321,784561,901594,260720,151375,905269,578744,503491,461620,803123,756971,778257,347679,728070,4773,153147,445196,565795,411555,146013,873502,619168,488167,672478,301759,800368,345800,730812,326665,206743,1032583,248176,560200,766071,718732,682986,844934,788543,1048360,637274,773856,135557,282492,997423,868913,420239,649339,406714,211800,40675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001222s ]