SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476873 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476873 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334579,717447,862708,552076,350669,881536,993555,755807,599396,856941,506378,457194,220994,622710,304524,57793,792276,807499,207478,250513,701954,810036,1003113,1034213,57720,366430,730506,331750,1030700,454118,229761,330834,828517,24077,922524,294002,34675,825488,459781,657130,1010545,326278,869341,1020989,352099,746972,633242,720717,926508,41524,648933,301901,43618,653668,986854,365954,1048232,190972,285662,469047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002086s ]