SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526452 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526452 [ RunTime:0.002858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70834,842830,926797,602545,758447,834903,341678,649609,8938,228772,662354,397083,63123,17592,145717,889012,659401,478601,294320,224172,848698,239611,167945,424024,721341,914854,659349,72669,606572,610327,169784,2070,416853,456464,811893,825263,833536,939090,45704,813028,23810,723097,640463,511705,340209,447351,241538,81675,1031973,36865,63423,112106,673209,267155,718626,462984,326748,251763,546529,232694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002962s ]