SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509016 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509016 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140167,232595,490126,212633,628853,26157,570011,733006,110281,144215,405883,937872,346118,718306,371373,639543,538272,318004,833308,410360,867968,603226,452675,39473,246192,613251,87294,643909,478829,445428,942564,92933,858065,606908,880208,459264,245680,603117,506698,355535,281257,759770,891226,518796,469585,216253,115967,852953,749641,912031,867544,548767,298665,569487,128896,615346,697340,272762,376521,280747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]