SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487401 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487401 [ RunTime:0.001458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865867,367654,266986,965365,190326,722359,728818,497260,164170,427632,283787,583820,762540,441123,139457,431387,682450,288252,802754,964932,216147,553428,430790,1047977,614425,911084,73104,359347,436236,1022171,775673,940272,880011,773388,204671,311216,88396,340800,621126,441763,967078,233198,1043521,377359,935577,461767,375585,824251,685141,617162,1044974,205168,168837,339913,833107,971019,143907,1011473,525575,1037026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]