SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490351 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490351 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534703,68119,8160,281706,275107,538931,672659,988600,115792,35364,1008155,338380,603403,115902,1048486,476710,621919,64973,174966,972633,562863,436787,1028746,326544,1027996,322510,665470,606987,79283,349132,798583,357270,559898,461575,390972,376075,545601,796773,157604,972468,563187,807259,926455,884635,637863,943712,283470,768173,653229,908136,378885,215212,1006482,769844,935819,266756,923205,945684,258373,854752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]