SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417858 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417858 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334318,376854,783739,490653,235320,168029,601002,126683,712737,744320,933972,143171,785434,731029,223224,1042384,975708,378754,945880,281297,252428,749977,267627,499347,642154,850568,68547,282970,258132,285145,445598,556256,337882,918678,769563,2625,573888,1025646,288887,749061,473666,878753,679775,150323,684706,1027461,162358,981979,713834,771261,91182,484135,55103,521136,310984,441726,988460,824949,1001638,45472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]