SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535199 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535199 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530557,629567,474199,578362,352173,535473,1008688,43313,905466,295675,608621,298752,15859,430441,809988,741189,598658,770196,1011065,509308,504165,815130,1021387,266227,617085,562291,599224,438291,110075,299934,370580,687259,144239,783871,709686,783116,321818,210342,798106,919574,883777,234926,1005840,440878,648713,70619,654873,1036421,576187,566095,983188,451363,363721,115571,419203,88830,938627,857694,990266,479504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]