SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429795 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429795 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819665,381724,617231,757449,347353,1004435,109985,123666,628659,397655,320622,287204,266829,63621,938064,294018,273096,646107,212544,360926,178047,751843,66493,28435,725169,909270,470225,679031,448642,814152,520463,299580,129930,933168,406164,149191,250613,272240,122569,622524,256425,50955,755345,154784,1029011,89745,802711,700501,690833,964587,380662,767285,168409,381086,287736,492647,36110,918181,907237,600969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]