SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040301 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040301 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946030,639160,186367,585754,247099,801470,303756,271983,10152,1009144,55735,409321,115452,840834,920141,547056,766652,398138,988622,903603,974915,207247,383843,703055,937553,1040466,638447,666574,15117,302610,34512,187118,183910,729075,187555,743079,499117,164978,554767,725003,967147,545043,49130,886636,905178,376965,244680,510630,884822,130890,810782,304960,327085,622461,876521,357026,559658,297425,926376,370277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]