SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504216 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504216 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503909,359913,964404,755641,347149,457932,878875,986021,568708,885129,537022,617247,719553,832299,711465,976274,135765,748047,625031,645300,844938,729304,526788,206590,592628,652832,634435,514706,682438,15868,850725,595771,225416,1006648,853034,821733,986903,709963,1004403,935805,265393,755230,957919,395354,486870,430207,16339,180860,796250,1035980,682144,922335,421847,755410,856714,615964,287668,5610,416859,922186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002577s ]