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` = 1019188 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019188 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671029,193557,579890,469195,549849,216208,141849,59234,906451,832603,327685,854513,481378,427491,205012,689631,208314,938155,247907,679302,369943,648057,568366,612022,797308,341791,600972,252030,68127,519369,327650,297675,700715,450394,851977,976351,983970,165770,871384,359117,318518,523296,518737,270320,629103,333198,558375,553378,646070,695479,738440,234366,486531,85932,576724,819881,634740,639486,63100,858942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]